~~ Context: DBNAME=JABBA, db_unique_name=JABBAPRD, instances JABBA1/JABBA2
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

mkdir -p /app/base/admin/JABBA
cd /app/base/admin/JABBA
mkdir scripts divers adump init diag

~~ initJABBA.ora
~~~~~~~~~~~~~~~~

*.db_name=JABBA
*.db_unique_name=JABBAPRD
*.compatible=12.1.0.2.0
*.control_files=(+DATA/JABBAPRD/control01.ctl,+DATA/JABBAPRD/control02.ctl)
*.db_create_file_dest=+DATA
*.db_create_online_log_dest_1=+DATA
*.db_recovery_file_dest_size=4G
*.db_recovery_file_dest=+RECO
*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'
*.log_archive_format=%t_%s_%r.arc
*.db_block_size=8192
*.open_cursors=300
*.diagnostic_dest=/app/base/admin/JABBA
*.sga_max_size=3G
*.sga_target=3G
*.pga_aggregate_target=512M
*.pga_aggregate_limit=1G
*.processes=350
*.audit_file_dest=/app/base/admin/JABBA/adump
*.audit_trail=db
*.remote_login_passwordfile=exclusive
JABBAPRD1.instance_number=1
JABBAPRD2.instance_number=2
JABBAPRD1.thread=1
JABBAPRD2.thread=2
JABBAPRD1.undo_tablespace=UNDOTBS1
JABBAPRD2.undo_tablespace=UNDOTBS2
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

startup nomount pfile='/mnt/yavin4/tmp/_oracle_/ad-hoc/initJABBA.ora'

create database JABBA
datafile  size 700M  autoextend on next  64M
extent management local
SYSAUX datafile  size 512M autoextend on next  64M
default temporary tablespace TEMP tempfile size 256M autoextend off
undo tablespace UNDOTBS1 datafile  size 256M autoextend off 
character set AL32UTF8 
national character set AL16UTF16 
logfile group 1 size 64M,
        group 2 size 64M
user SYS identified by secret user SYSTEM identified by secret;

create undo tablespace UNDOTBS2 datafile size 256M autoextend off;
create tablespace USERS datafile size 32M autoextend ON next 32M;
alter database default tablespace USERS;

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catclust.sql
@?/rdbms/admin/utlrp.sql


alter database add logfile thread 2 
  group 3  size 64M,
  group 4  size 64M;
 
alter database enable public thread 2; 


~~ add cluster_database=true in init.ora and restart instance on 2 nodes
startup pfile='/mnt/yavin4/tmp/_oracle_/ad-hoc/initJABBA.ora'

~~ create spfile on ASM
create spfile='+DATA/JABBAPRD/spfileJABBA.ora' from pfile='/mnt/yavin4/tmp/_oracle_/ad-hoc/initJABBA.ora';

~~ on both nodes, create init.ora under $ORACLE_HOME/dbs
echo "spfile='+DATA/JABBAPRD/spfileJABBA.ora'" > $ORACLE_HOME/dbs/initJABBAPRD1.ora
echo "spfile='+DATA/JABBAPRD/spfileJABBA.ora'" > $ORACLE_HOME/dbs/initJABBAPRD2.ora

~~ register DB in CRS
srvctl add database -d JABBAPRD -pwfile '+DATA/JABBAPRD/orapwJABBA' -o /app/oracle/product/12.1 -p '+DATA/JABBAPRD/spfileJABBA.ora' 

~~ create passwordfile on ASM; if the DB is not yet registered on CRS, you will get a WARNING
orapwd FILE='+DATA/JABBAPRD/orapwJABBA' ENTRIES=10 DBUNIQUENAME='JABBAPRD' password=secret

srvctl add instance -d JABBAPRD -i JABBAPRD1 -n vortex-db01
srvctl add instance -d JABBAPRD -i JABBAPRD2 -n vortex-db02

~~ shutdown both instances with SQL*Plus, therfore start DB with srvctl
srvctl start database -db JABBAPRD
srvctl status database -db JABBAPRD -v

~~ enable ARCHIVELOG mode
alter system set cluster_database=false scope=spfile sid='*';
srvctl stop database -db JABBAPRD

startup mount exclusive
alter database archivelog;
alter database open;
alter system set cluster_database=true scope=spfile sid='*';

~~ shutdown database within SQL*Plus, therefore start with srvctl
srvctl start database -db JABBAPRD
